<%@ page language="java" contentType="text/html; charset=ISO-8859-1" pageEncoding="ISO-8859-1" import="java.sql.*" import="Connect.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<link rel="stylesheet" type="text/css" href="style.css" media="screen" />
<title>Hammer Time Auctions</title>
</head>
<body>
	<div id="content">
		<%@include file="header.jsp"%>
		<h1>Help</h1>
		<hr></hr>
		<h2 class="center-text">Hammer Time Auctions User Guide</h2>
		<div class="center" style="width: 80%;">
			<ol>
				<li><a href="#who_we_are">Who We Are</a></li>
				<li><a href="#getting_started">Getting Started</a></li>
				<li><a href="#dashboard_explained">Dashboard Explained</a>
				<ol>
						<li><a href="#customer">Customer</a></li>
						<li><a href="#employee">Employee</a></li>
						<li><a href="#manager">Manager</a></li>
					</ol></li>
				<li><a href="#customer_help">Customer Help</a></li>
				<li><a href="#employee_help">Employee Help</a></li>
				<li><a href="#manager_help">Manager Help</a></li>
			</ol>
			<h3>
				<a id="who_we_are">Who We Are</a>
			</h3>
			We are a group of students taking the Databases course at Stony Brook University.<br /> Kevin Li - Design and Coding<br /> James Ju - Coding<br />
			William Cheng - Coding<br />
			<h3>
				<a id="getting_started">Getting Started</a>
			</h3>
			The first accessing the webpage there won't be much functionality available to you if you don't have an account. Create an account by clicking the
			register link on the upper left of the page. After you finish registering you will be directed to the login page. If you already have an account
			simply click the login link and enter your credentials. Once you are logged in you will be brought to the dashboard page. This page displays a list
			of general functionality available to you. The Home button at the top of the page will always direct you back to your dashboard. You can always
			access the Help page on the top right of every page.<br />
			<h3>
				<a id="dashboard_explained">Dashboard Explained</a>
			</h3>
			The following section explains the basic function of each dashboard link. <br /> <a id="customer"><b>Customer</b></a>
			<ul>
				<li><b>View Item Selection - </b>This page displays a list of items stored in Hammer Time Auctions' database. Use the search bar near the top
					of the page to filter the list of items. The New Item button allows you to add an item to the database. The Create Auction button lets you post
					an auction for the selected item.</li>
				<li><b>Edit Profile - </b>This page lets you edit your personal information in case something has changed since you've registered.</li>
				<li><b>My Bid History - </b>This page displays every auction you have participated in. They are separated into four categories. These are
					Current Auctions, Auctions Won, Auctions Lost, and Did Not Meet Reserve. Current Auctions are auctions that have not yet expired. Auctions Won
					are auctions where you are the highest bidder and the bid is above the reserve price (if there was one). Auctions Lost are auctions where you
					have placed a bid but was not the highest bidder. Did Not Meet Reserve are auctions you have won but did not bid more than the reserve price and
					therefore did not win.</li>
				<li><b>Get Best Sellers List - </b>This page lists items ordered in descending order based on the number of copies sold.</li>
			</ul>
			<a id="employee"><b>Employee</b></a>
			<ul>
				<li><b>Record Sales - </b>Whenever an auction expires and someone has won it, it is the job of the auction's monitor to record the sale.
					Recording a sale means that the seller has received payment and the buyer has received the item. Recording a sale also increases the rating of
					the buyer and seller by one.</li>
				<li><b>Manage Customers - </b>This page displays a list of all the customers that have registered for Hammer Time Auctions. You can click on
					the + New User button to add a new customer to the database. You can click the Edit button next to any user to edit the information for that
					customer. The editing page also allows you to delete the user.</li>
				<li><b>Get Recommendations For A Customer - </b>After you specify a customer, a list of recommended items will be generated for that
					customer.</li>
				<li><b>Get Customer Mailing List - </b>This page displays a list of customers and their corresponding email address.</li>
				<li><b>View Employee List - </b>This page displays the entire list of people employed by Hammer Time Auctions.</li>
				<li><b>Edit Profile - </b>This page lets you edit your personal information in case something has changed since you've been employed.</li>
			</ul>
			<a id="manager"><b>Manager</b></a>
			<ul>
				<li><b>In addition to all the functions available to an employee you also have the following functions.</b></li>
				<li><b>View Sales Reports - </b>This page displays all auctions that have expired. Near the top of the page is a search bar with several
					options. The text field specifies which string pattern to look for. The category field specifies what part of the auction information to look for
					the string pattern in. The sort by field specifies how you want the results to be ordered. The order by field lets you choose whether you want
					the results to be in ascending or descending order. Next to the Filter button there is a Total Revenue button. Clicking this will bring you to a
					summary table that tells you the total price of all the auctions in the subset sold for as well as the 10% earned by the website.</li>
				<li><b>View Item Selection - </b>This page displays a list of items stored in Hammer Time Auctions' database. Use the search bar near the top
					of the page to filter the list of items. The New Item button allows you to add an item to the database. As the manager you can edit the
					information of an item if you find a mistake.</li>
				<li><b>View Revenue Generated By Employees - </b>This page lists every employee as well as the total revenue the employee is responsible for
					has earned and how much the website has earned from them. The bottom of the page lists the highest earning employee.</li>
				<li><b>View Revenue Generated By Customers - </b>This page lists every customer as well as the total revenue has earned from auctions the
					customer has posted and how much the website has earned from them. The bottom of the page lists the highest earning customer.</li>
				<li><b>Get Best Sellers List - </b>This page lists items ordered in descending order based on the number of copies sold.</li>
				<li><b>Manage Employees - </b>This page displays a list of all the employees employed by Hammer Time Auctions. You can click on the + New
					User button to add a new employee to the database. You can click the Edit button next to any user to edit the information for that customer. The
					editing page also allows you to delete the user.</li>
				<li><b>Backup Databases - </b>Clicking this link will create a SQL file containing the schema for Hammer Time Auctions with all the table
					data in the database.</li>
			</ul>
			<h3>
				<a id="customer_help">Customer Help</a>
			</h3>
			<ul>
				<li><b>View Bid History of an Auction - </b>If you are interested in viewing the bid history of a particular auction simply click the View
					Bid History button corresponding to the auction. To reach the bid history page click the View Item Selection Link > View Auctions Button > View
					Bid History Button.</li>
				<li><b>Personal Bid History - </b>Simply click the My Bid History link to view all auctions you have participated in.</li>
				<li><b>Find Items Sold by a Specific Customer - </b>You can click the owner of an auction to view all auctions that he has posted or
					alternatively you can find click View Item Selection and filter by Customer.</li>
				<li><b>Find Items By Type - </b>You can search for specific item types by clicking View Item Selection and filtering by item type.</li>
				<li><b>Find Items Using Keywords - </b>You can search for items by keywords by clicking View Item Selection and filtering by item name or
					description.</li>
				<li><b>Get Best-Sellers List - </b>You can get a list of the best-selling items by clicking the Get Best Sellers List.</li>
				<li><b>Personalized Item Suggest List - </b>If you want some suggestions on what items you should buy click this in order to get
					recommendations based on past purchases.</li>
				<li><b>Placing a Bid - </b>To place a bid on the auction you are interested in simply find the auction you want by clicking View Item
					Selection > View Auctions > Entering a Bid > Click the Place Bid button. Every auction has an indicator next to the current bid that tells you
					whether the Reserve Price (if there is one) has been met and whether or not you are the highest bidder.</li>
			</ul>
			<h3>
				<a id="employee_help">Employee Help</a>
			</h3>
			<ul>
				<li><b>Record A Sale - </b>If you want to confirm the payment and receipt of items for an auction click Record Sale link > Click Finish
					button.</li>
				<li><b>Add, Edit or Delete Information for a Customer - </b>Click Manage Customers link and choose the correct option from that page.</li>
				<li><b>Produce Customer Mailing List - </b>Click the Get Customer Mailing List link.</li>
				<li><b>Make Suggestions for a Customer - </b>Click the Get Recommendations for a Customer link > Enter a customer name.</li>
			</ul>
			<h3>
				<a id="manager_help">Manager Help</a>
			</h3>
			<ul>
				<li><b>Obtain a Sales Report for a Particular Month - </b>To get the sales report for a particular month click the Get Sales Report link and
					enter the month in yyyy-mm format and select End Date as the category.</li>
				<li><b>Produce List of All Items - </b>Click the View List of Items link to get a list of all the items in the database.</li>
				<li><b>Produce a List of Sales by Item Name or by Customer Name - </b>First click the View Sales Report link. In order get sales by Item name
					you can enter a specific item name into the search bar or you can leave it blank and have it sorted by Item Name. To get the sales by Customer
					name leave the search field blank and have it sorted by customer name.</li>
				<li><b>Produce a Summary Listing of Revenue Generated by a particular item, item type, or customer - </b>To get a summary listing of an item
					or item type click the View Sales Report Link > Enter the item name or item type and select Item or Item Type as the category and use the same
					for the sorting > Click the Filter button to get your subset. To get a summary listing of revenue by customer you should use the View Revenue
					Generated by Customer link.</li>
				<li><b>Determine which employee generated the most revenue - </b>If you want to find out which employee has monitored the most in terms of
					revenue, click View Revenue Generated by Employees link and scroll to the bottom.</li>
				<li><b>Determine which customer generated the most revenue - </b>If you want to find which customer has sold the most in terms of revenue,
					click View Revenue Generated by Customers link and scroll to the bottom.</li>
				<li><b>Get Best-Sellers List - </b>You can get a list of the best-selling items by clicking the Get Best Sellers List.</li>
				<li><b>Add or Delete Any User - </b>You can add or delete a customer by using the Manage Customers link and you can add or delete an employee
					using the Manage Employees link.</li>
				<li><b>Backup Database - </b>If you ever need to move the database simply click the Backup Database link and a SQL file will be exported for
					you.</li>
			</ul>
		</div>
	</div>
	<hr></hr>
	<%@include file="footer.jsp"%>
</body>
</html>